package jdbc;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

/**
 * 登录功能
 * 程序启动后，要求用户输入用户名和密码
 * 使用该用户名和密码去userinfo表中查询，如果存在，则登录成功，否则提示用户名密码错误
 * */
public class LoginDemo {
    public static void main(String[] args) {
        try (Connection con = DBUtil.getConnection()) {
            Statement stmt = con.createStatement();
            UserInfo userInfo = InputUtil.getInputObject(new UserInfo(),"欢迎登录","登录");
            String sql = "SELECT password,username "+
                         "FROM userinfo "+
                         "WHERE username = '"+userInfo.getUsername()+"' "+
                         "AND password = '"+userInfo.getPassword()+"'";
            ResultSet rs = stmt.executeQuery(sql);
            if (rs.next()){
                System.out.println("登录成功");
            }else {
                System.out.println("登录失败，用户名或密码错误");
            }

        }catch (SQLException e){
            e.printStackTrace();
        }
    }
}
